Insights and visualisation from WeRateDogs tweets

WeRateDogs is twitter account for rating tweets with funny content related to dogs. I have analysed 1958 dog tweets which were posted on the account in period from 15th November 2015 to 1st August 2017. On WeRateDogs special evaluation for tweets is used. Score for photo or video provided by user is given on scale 1 to 10, but quitte often it is above like 13/10 or 12/10, while 14/10 is considered as max score.

I would like to present main findings from group of analysed tweets which can be further divided into answers for three main questions:

  • What day is the best for posting the tweet if user wants to gain as much likes as possible?
  • What are the characteristics of popular tweet?
  • What words are most often used to present dogs in tweets?

Best day for posting tweet

From graph below we can see that tweets are posted more often on weekdays than on weekends. Highest number of tweets is on average being posted on Mondays (324 tweets a day) and lowest on Saturday (248 tweets). But people tend to give the most likes for a tweet on Wednesdays (9250 likes for a tweet on average) and Sundays (8713 likes). The least likes given to single tweet on average appear on Mondays and Thursdays.

Therefore if users know how long it normally takes for twitter admins to publish content, they can send their photos or videos of dogs accordingly, so that tweet will appear on Wednesdays or Sundays.

Average%20number%20of%20likes%20and%20tweets%20during%20week.png

What kind of tweets are popular?

In terms of different dog breeds, the most likes on average were getting tweet with one of these 5 breeds; Bedlington Terrier, Saluki, French Bulldog, Bouvier Des Flandres and Afghan Hound. The most retweets on average appeared for 5 following breeds; Bedlington Terrier, Afghan Hound, Standard Poodle, French Bulldog and English Springer.

Looking on 15 top dog breeds for getting most likes and retweets on average, we must conclude that most popular dog breeds on WeRateDogs are Bedlington Terrier, Afghan Hound, French Bulldog and Saluki.

15%20dog%20breeds%20with%20most%20likes%20on%20average.png

15%20dog%20breeds%20with%20most%20retweets%20on%20average.png

My initial thought was that people probably like more tweets where puppies appear. If text of tweet included any of words "puppy", "puppies", "pup" or "pup's", I labeled them as tweet with puppies. Like this I had 96 tweets with puppies and 1862 tweets without puppies.

But my initial idea was far from truth when I regarded data about average likes and retweets for tweets with and without puppies. Tweets with puppies gained less likes and retweets than tweets without them.

Popularity%20of%20tweets%20with%20and%20without%20puppies.png

Later, when checking 5 tweets with most likes and 5 tweets with most retweets, I noticed that 7 out of 10 these most popular tweets are tweets containing videos, not photo. Therefore I performed similar analysis on tweets with photos and tweets with videos as in previous case with/without puppies.

We can clearly see on graph below that tweets with videos gain on average much more likes as well as retweets. To be more eaxct, tweet with video has on average 2,7 times more likes and 4 times more retweets than tweet with photo.

popularity%20of%20tweets%20with%20photos%20and%20videos.png

Which words appear most often in tweets of WeRateDogs?

Usually, we can find words used in simple introduction, like "This", "This is", "Meet", "Say hello" and "He" or "She" pronouns for talking about dogs. On graph below 150 most often used words in WeRateDogs tweets appear.

word_id_tweets.png

In [ ]: